SET IDENTITY_INSERT MyTable ON -- INSERT INTO MyTable... SET IDENTITY_INSERT MyTable OFF